SET IDENTITY_INSERT [dbo].[store] ON;
Select * from store where store_id = 297;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('297', 'Cash Crusaders Jackal Creek','Cash Crusaders Stores (Pty)Ltd','Cash Crusaders Jackal Creek','Shop 35 and 36 Jackal Creek Corner
Boundary Road and Auroele Ave North Riding','TBA','TBA','TBA','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Jackal Creek',CompanyName = 'Cash Crusaders Stores (Pty)Ltd', TradingAs = 'Cash Crusaders Jackal Creek', Address='Shop 35 and 36 Jackal Creek Corner Boundary Road and Auroele Ave North Riding', ContactNo = 'TBA', VATRegNo = 'TBA',RegNo = 'TBA', StoreEmailAddress = 'TBA' where Store_ID = 297;
 END
 SET IDENTITY_INSERT [dbo].[store] off